File manager - Edit - /home/autoph/public_html/projects/app/Http/Controllers/API/v1/AdjustmentsAndDeductionsController.php
Back
<?php namespace App\Http\Controllers\API\v1; use App\Http\Controllers\Controller; use App\Models\AdjustmentsAndDeductions; use App\Models\Employee; use App\Models\EmployeeBenefits; use Illuminate\Http\Request; use Illuminate\Http\Response; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Validator; use Illuminate\Validation\Rule; use Throwable; class AdjustmentsAndDeductionsController extends Controller { public function index(Request $request) { $keyword = $request->input('keyword', ''); $perPage = $request->input('per_page', PHP_INT_MAX); $sortBy = $request->input('sortBy', ''); $sortType = $request->input('sortType', ''); $data = AdjustmentsAndDeductions::with(['employee:employee_id,firstname,lastname', 'payroll_item:id,name']) ->whereHas('employee', function ($query) use ($keyword) { $keyword = str_replace(" ", "%", $keyword); // format keyword for partial matching $query->where('employee_id', 'like', '%' . $keyword . '%') ->orWhere('firstname', 'like', '%' . $keyword . '%') ->orWhere('lastname', 'like', '%' . $keyword . '%'); }); // Handling sorting if (!empty($sortBy) && !empty($sortType)) { // Check if the sortBy is 'fullname', then sort by both firstname and lastname if ($sortBy === 'fullname') { $data = $data->join('employees', 'adjustments_and_deductions.employee_id', '=', 'employees.employee_id') ->orderBy('employees.firstname', $sortType) ->orderBy('employees.lastname', $sortType); } else { $data = $data->orderBy($sortBy, $sortType); } } $data = $data->paginate($perPage); return response()->json($data); } public function store(Request $request) { $recurring = ($request->recurring && $request->recurring !== 'null' && $request->recurring !== 'false' && trim($request->recurring) !== '' ? 1 : 0); $request['recurring'] = $recurring; // Validate the incoming request data $validator = Validator::make($request->all(), [ 'employee_id' => [ 'required', ], 'payroll_item_id' => [ 'required', ], 'date_from' => [ 'required', ], 'amount' => [ 'required', ], 'frequency' => [ 'required', ], ]); /** If validation fails return with error message */ if ($validator->fails()) { $errors = $validator->errors(); $first = $errors->getMessages(); return response()->json([ 'status' => false, 'message' => (reset($first))[0], 'errors' => $errors ], Response::HTTP_UNPROCESSABLE_ENTITY); } DB::connection()->beginTransaction(); try { foreach ($request->employee_id as $employee) { $employee_info = Employee::select('company_id', 'dealer_id')->where('employee_id', $employee)->first(); $request['company_id'] = $employee_info->company_id; $request['dealer_id'] = $employee_info->dealer_id; $request['employee_id'] = $employee; $data = AdjustmentsAndDeductions::create($request->all()); DB::connection()->commit(); } // $data = AdjustmentsAndDeductions::create($request->all()); // DB::connection()->commit(); return response()->json([ 'message' => 'Record Successfully added!', 'status' => 'success', ],201); } catch (Throwable $e) { DB::connection()->rollback(); return response()->json([ 'status' => false, 'message' => 'Unable to process request. Please try again.', 'data' => $e->getMessage() ]); } } public function update(Request $request, int $id) { $data = AdjustmentsAndDeductions::where('id', $id)->first(); if (!$data) { return response()->json(['messages' => 'No data found.'], 404); } $recurring = ($request->recurring && $request->recurring !== 'null' && $request->recurring !== 'false' && trim($request->recurring) !== '' ? 1 : 0); $request['recurring'] = $recurring; $validator = Validator::make($request->all(), [ 'employee_id' => [ 'required', ], 'payroll_item_id' => [ 'required', ], 'date_from' => [ 'required', ], 'amount' => [ 'required', ], 'frequency' => [ 'required', ], ] ); /** If validation fails return with error message */ if ($validator->fails()) { $errors = $validator->errors(); $first = $errors->getMessages(); return response()->json([ 'status' => false, 'message' => (reset($first))[0], 'errors' => $errors ], Response::HTTP_UNPROCESSABLE_ENTITY); } DB::connection()->beginTransaction(); try { $data->fill($request->all()); $data->save(); $data->touch(); DB::connection()->commit(); return response()->json([ 'message' => 'Record Successfully updated!', 'status' => 'success', 'data' => $data, ],201); } catch (Throwable $e) { DB::connection()->rollback(); return response()->json([ 'status' => false, 'message' => 'Unable to process request. Please try again.', 'data' => $e->getMessage() ]); } } public function destroy(int $id) { $data = AdjustmentsAndDeductions::find($id); if(!$data) { return response()->json(['message' => "Record not found!"],204); } DB::connection()->beginTransaction(); $data->delete(); DB::connection()->commit(); return response()->json(['message' => "Record successfully deleted!"],201); } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0.03 |
proxy
|
phpinfo
|
Settings